<template>
	<el-card>
		<el-form :inline="true" :model="state.queryForm" @keyup.enter="getDataList()">
			<el-form-item>
				<el-input v-model="state.queryForm.connName" placeholder="连接名"></el-input>
			</el-form-item>
			<el-form-item prop="dbType">
				<el-select v-model="state.queryForm.dbType" clearable placeholder="数据库类型">
					<el-option value="MySQL" label="MySQL"></el-option>
					<el-option value="Oracle" label="Oracle"></el-option>
					<el-option value="PostgreSQL" label="PostgreSQL"></el-option>
					<el-option value="SQLServer" label="SQLServer"></el-option>
					<el-option value="DM" label="达梦8"></el-option>
				</el-select>
			</el-form-item>
			<el-form-item>
				<el-button @click="getDataList()">查询</el-button>
			</el-form-item>
			<el-form-item>
				<el-button type="primary" @click="addOrUpdateHandle()">新增</el-button>
			</el-form-item>
			<el-form-item>
				<el-button type="danger" @click="deleteBatchHandle()">删除</el-button>
			</el-form-item>
		</el-form>
		<el-table v-loading="state.dataListLoading" :data="state.dataList" border style="width: 100%" @selection-change="selectionChangeHandle">
			<el-table-column type="selection" header-align="center" align="center" width="50"></el-table-column>
			<el-table-column prop="connName" label="连接名" header-align="center" align="center"></el-table-column>
			<el-table-column prop="dbType" label="数据库类型" header-align="center" align="center"></el-table-column>
			<el-table-column prop="connUrl" label="数据库URL" show-overflow-tooltip header-align="center" align="center"></el-table-column>
			<el-table-column prop="username" label="用户名" header-align="center" align="center"></el-table-column>
			<el-table-column label="密码" header-align="center" align="center">
				<template #default="scope">
					<span>{{ formatPassword(scope.row.password) }}</span>
				</template>
			</el-table-column>
			<el-table-column label="操作" fixed="right" header-align="center" align="center" width="170">
				<template #default="scope">
					<el-button type="primary" link @click="datasourceHandle(scope.row.id)">测试</el-button>
					<el-button type="primary" link @click="addOrUpdateHandle(scope.row.id)">编辑</el-button>
					<el-button type="primary" link @click="deleteBatchHandle(scope.row.id)">删除</el-button>
				</template>
			</el-table-column>
		</el-table>
		<el-pagination
			:current-page="state.page"
			:page-sizes="state.pageSizes"
			:page-size="state.limit"
			:total="state.total"
			layout="total, sizes, prev, pager, next, jumper"
			@size-change="sizeChangeHandle"
			@current-change="currentChangeHandle"
		>
		</el-pagination>

		<!-- 弹窗, 新增 / 修改 -->
		<add-or-update ref="addOrUpdateRef" @refresh-data-list="getDataList"></add-or-update>
	</el-card>
</template>

<script setup lang="ts">
import { reactive, ref } from 'vue'
import { IHooksOptions } from '@/hooks/interface'
import { useDataSourceTestApi } from '@/api/datasource'
import { useCrud } from '@/hooks'
import { ElMessage } from 'element-plus'
import AddOrUpdate from './add-or-update.vue'
import { decrypt } from '@/utils/tool'

const state: IHooksOptions = reactive({
	dataListUrl: '/gen/datasource/page',
	deleteUrl: '/gen/datasource',
	queryForm: {
		connName: '',
		dbType: ''
	}
})

const datasourceHandle = (id: number) => {
	useDataSourceTestApi(id).then((res: any) => {
		ElMessage.success(res.data)
	})
}

const addOrUpdateRef = ref()
const addOrUpdateHandle = (id?: number) => {
	addOrUpdateRef.value.init(id)
}

const { getDataList, selectionChangeHandle, sizeChangeHandle, currentChangeHandle, deleteBatchHandle } = useCrud(state)

const formatPassword = (str: string): string => {
	return Array(decrypt(str).length).fill('•').join('')
}
</script>
